County Profile for Franklin - 2012



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2012 0
Total Cost Reports Filed in 2012 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 0 Net Population Natural Change 0
Total Cost Reports Reopened 1 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 19,729,556 Total Charges 175,789,238
Fixed Assets 38,621,125 Contract Allowance 88,829,965
Other Assets 17,818,323 Operating Revenue 86,959,273
Total Assets 76,169,004 Operating Expenses 89,726,136
Current Liabilities 9,299,724 Operating Margin -2,766,863
Long Term Liabilities 25,636,466 Other Income 6,479,152
Total Equity 41,232,814 Other Expense 3,725,281
Total Liabilities and Equity 76,169,004 Net Profit or Loss -12,992

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $29,299 Revenue per Bed $1,976,347 Revenue per Person $86,959,273
Net Margin per Discharge ($932) Net Margin per Bed ($62,883) Net Margin per Person ($2,766,863)
Net Profit per Discharge ($4) Net Profit per Bed ($295) Net Profit per Person ($12,992)
Net Fixed Assets per Discharge $13,013 Net Fixed Assets per Bed $877,753 Net Fixed Assets per Bed $38,621,125
Long Term Debt per Discharge $8,638 Long Term Debt per Bed $582,647 Long Term Debt per Person $25,636,466
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 54.1 %
Length of Stay 3 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,063 Net Fixed Assets 1,006 Population Estimate 1,151
Total Revenue 967 Long Term Liabilities 908 Total Patient Discharges 1,074
Net Margin 2,534 Total Patient Beds 1,437
Net Profit or Loss 2,590

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 10,374,867 14,146,868 0.7334
31 Intensive Care Unit 1,946,022 2,004,618 0.9708
32 Coronary Care Unit 0 0
43 Nursery 861,562 1,102,442 0.7815
44 Skilled Nursing Care 0 0
50 Operating Room 6,765,121 18,985,382 0.3563
51 Recovery Room 0 0
52 Labor and Delivery Room 248,836 379,448 0.6558

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,174,787 13 Nursing Administration 792,203
02,03 Captial Related - Movable Equipment 2,346,979 14 Central Services and Supply 602,241
04 Employee Benefits 9,687,000 15 Pharmacy 1,535,995
05 Administrative and General 11,582,702 16 Medical Records and Medical Library 1,299,063
06 Maintenance and Repairs 888,663 17 Social Services 770,500
07 Operation of Plant 1,175,163 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 939,285 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 649,295 20,21,22,23 Education Programs 0
Total General Service Cost Centers 35,443,876

County Profile for Franklin - 2012